package com.easyder.data;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DBHelper extends SQLiteOpenHelper {
     private static final String DATABASE_NAME = "kkshop.db";
     private static final int DATABASE_VERSION = 1 ;
	public DBHelper(Context context) {
		super(context,DATABASE_NAME, null, DATABASE_VERSION);
	}
///
	@Override
	public void onCreate(SQLiteDatabase db) {
    	String sql1 = "CREATE TABLE person " +
    			"(_id INTEGER PRIMARY KEY AUTOINCREMENT, id VARCHAR,username VARCHAR,email VARCHAR,telphone VARCHAR,realname VARCHAR,namekey VARCHAR,thetitle VARCHAR," +
    			"QQ VARCHAR,sinaweibo VARCHAR,QQweibo VARCHAR,middlephoto VARCHAR,company VARCHAR,department VARCHAR,jobtitle VARCHAR,borndate VARCHAR," +
    			"addr VARCHAR,hobby VARCHAR,pinyin VARCHAR,company_pinyin VARCHAR,monitor VARCHAR,mobile VARCHAR,sex VARCHAR,cname VARCHAR,cname1 VARCHAR,cname2 VARCHAR,committee VARCHAR,vip_show INTEGER)";
    	db.execSQL(sql1);	    
	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		
	}

}
